using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using FarPoint.Win.Spread;
using FarPoint.Win;
using FarPoint.Win.Spread.CellType;
using GrapeCity.PointTable.SparkLines;
using FarPoint.Win.Spread.Chart;
using FarPoint.Win.Spread.Data;
using Spread.Common.Features.Sample;
using Spread.Common.DataStore.Models;
using Spread.Common.DataStore;

namespace GrapeCity.PointTable
{
    public partial class GCPointTableControl : BaseSampleControl
    {
        #region PrivateMembers
        private FpSpread fpSpread;

        private List<Team> teamList;
        private List<Match> matchListCurrent;
        private List<Match> matchListPrevious;
        private List<MatchPointTable> pointTableListCurrent;
        private List<MatchPointTable> PointTanbleListPrevious;
        private string selectedYr = "";
        private List<string> year = null;
        private DataService _dataService;
        #endregion

        #region ctor
        public GCPointTableControl()
        {
            InitializeComponent();

            AddUIControls();

            Load += GCPointTableControl_Load;
        }
        #endregion

        #region Events
        private void GCPointTableControl_Load(object sender, EventArgs e)
        {
            _dataService = new DataService();

            SetRowColCount();
            AddEventHandlers();
            SetCellType();
            teamList = _dataService.JsonDataSource.GetAllTeams();
            string[] selectedYrs = selectedYr.Split('-');
            List<Match>[] currentAndPreviousMatches = _dataService.JsonDataSource.GetCurrentAndPreviousMatches(
                selectedYrs.Count() < 2 ? Convert.ToInt32(selectedYrs[0]) : Convert.ToInt32(selectedYrs[1]), selectedYr);
            matchListCurrent = currentAndPreviousMatches[0];
            matchListPrevious = currentAndPreviousMatches[1];
            pointTableListCurrent = CreatePointTable(matchListCurrent);
            PointTanbleListPrevious = CreatePointTable(matchListPrevious);
            UpdateRank(pointTableListCurrent, PointTanbleListPrevious);
            UpdateDataOnSpread();
            CreateSparkLineForWinLoss();
            SetColor();
            SetColumnsRowsVisibility();
            SetFont();
            SetColWidth();
            SetHeaderAndText();
        }

        private void FpSpread_ComboSelChange(object sender, EditorNotifyEventArgs e)
        {
            string _ctrlTxt = (e.EditingControl as FpCombo).SelectedItem.ToString();
            selectedYr = year.IndexOf(_ctrlTxt) >= 0 ? year[year.IndexOf(_ctrlTxt)] : selectedYr;
            ProgressForm pf = new ProgressForm();
            Task.Factory.StartNew(() =>
            {

                this.BeginInvoke((System.Action)(() =>
                {
                    fpSpread.Sheets[0].Cells[1, 4].Text = selectedYr.ToString();
                    pf.Location = PointToScreen(pnlMain.Location);
                    pf.Size = pnlMain.Size;
                    pf.Opacity = 0.6;
                    pf._progressBar.Width = pf.Width / 2;
                    pf._progressBar.Height = 30;
                    pf._progressBar.Location = new Point(pf.Width / 2 - pf.Width / 4, pf.Height / 2 - 15);
                    pf.ShowDialog();
                }));
                fpSpread.SuspendLayout();
                string[] selectedYrs = selectedYr.Split('-');
                List<Match>[] currentAndPreviousMatches = _dataService.JsonDataSource.GetCurrentAndPreviousMatches(
                    selectedYrs.Count() < 2 ? Convert.ToInt32(selectedYrs[0]) : Convert.ToInt32(selectedYrs[1]),
                    selectedYr);
                matchListCurrent = currentAndPreviousMatches[0];
                matchListPrevious = currentAndPreviousMatches[1];
                pointTableListCurrent = CreatePointTable(matchListCurrent);
                PointTanbleListPrevious = CreatePointTable(matchListPrevious);
                UpdateRank(pointTableListCurrent, PointTanbleListPrevious);
                UpdateDataOnSpread();
                CreateSparkLineForWinLoss();
                this.BeginInvoke((System.Action)(() =>
                {
                    pf.Dispose();
                }));
                fpSpread.ResumeLayout();
            });
        }

        private void FpSpread_EditChange(object sender, EditorNotifyEventArgs e)
        {
            if (e.Column >= 5 && e.Column <= 8)
            {
                int total = Convert.ToInt32(fpSpread.Sheets[0].Cells[e.Row, 5].Text);
                int win = Convert.ToInt32(fpSpread.Sheets[0].Cells[e.Row, 6].Text);
                int loss = Convert.ToInt32(fpSpread.Sheets[0].Cells[e.Row, 7].Text);
                int draw = Convert.ToInt32(fpSpread.Sheets[0].Cells[e.Row, 8].Text);
                if (total < (win + loss + draw))
                {
                    fpSpread.CancelCellEditing();
                    MessageBox.Show("Total match (M) must be greater or equal to Won(W)+L(Loss)+D(Draw).");
                }
            }
        }
        #endregion

        #region Methods
        private void AddUIControls()
        {
            fpSpread = new FpSpread();
            fpSpread.Sheets.Clear();
            fpSpread.Sheets.Add(new SheetView());
            fpSpread.Dock = DockStyle.Fill;

            pnlMain.Controls.Add(fpSpread);
        }

        private void SetRowColCount()
        {
            fpSpread.Sheets[0].Rows.Count = 18;
            fpSpread.Sheets[0].Columns.Count = 15;
        }
        private void SetRowHeight(int rowCnt)
        {
            for (int i = 3; i < rowCnt + 3; i++)
            {
                fpSpread.Sheets[0].SetRowHeight(i, 35);
            }
        }
        private void SetColWidth()
        {

            for (int i = 0; i < 9; i++)
            {
                fpSpread.Sheets[0].Columns[i].Width = 35;
            }
            fpSpread.Sheets[0].Columns[4].Width = 200;
            for (int i = 9; i < 15; i++)
            {
                fpSpread.Sheets[0].Columns[i].Width = 130;
            }
        }
        private void SetFont()
        {
            //Set font
            fpSpread.Font = new Font("MS Sans Serif", 9, FontStyle.Regular);
            fpSpread.Sheets[0].Rows[0].Font = new Font("MS Sans Serif", 18, FontStyle.Bold);
            fpSpread.Sheets[0].Columns[4].Font = new Font("MS Sans Serif", 10, FontStyle.Regular);
            fpSpread.Sheets[0].Rows[1, 2].Font = new Font("MS Sans Serif", 9, FontStyle.Bold);
            fpSpread.Sheets[0].Rows[0].HorizontalAlignment = CellHorizontalAlignment.Center;
            fpSpread.Sheets[0].Rows[2].HorizontalAlignment = CellHorizontalAlignment.Center;
            fpSpread.Sheets[0].Rows[0, fpSpread.Sheets[0].Rows.Count - 1].VerticalAlignment = CellVerticalAlignment.Center;
            fpSpread.Sheets[0].Cells[1, 0].HorizontalAlignment = CellHorizontalAlignment.Right;
            fpSpread.Sheets[0].Columns[1, 2].HorizontalAlignment = CellHorizontalAlignment.Right;
        }
        private void SetCellType()
        {

            NumberCellType numberCellType = new NumberCellType();
            numberCellType.NullDisplay = "0";
            numberCellType.DecimalPlaces = 2;
            numberCellType.MinimumValue = 0;
            fpSpread.Sheets[0].Columns[10].CellType = numberCellType;
            fpSpread.Sheets[0].Columns[11].CellType = numberCellType;
            TextCellType textCellType = new TextCellType();
            fpSpread.Sheets[0].Cells[1, 10, 2, 10].CellType = textCellType;
            fpSpread.Sheets[0].Cells[1, 11, 2, 11].CellType = textCellType;
            fpSpread.Sheets[0].Cells[2, 5].CellType = textCellType;
            fpSpread.Sheets[0].Cells[2, 6].CellType = textCellType;
            fpSpread.Sheets[0].Cells[2, 7].CellType = textCellType;
            fpSpread.Sheets[0].Cells[2, 8].CellType = textCellType;
            fpSpread.Sheets[0].Cells[1, 0].Text = "Select Year : ";
            ComboBoxCellType comboBoxCellType = new ComboBoxCellType();
            year = new List<string>();
            year.AddRange(new string[]
            {
                (DateTime.Now.Year-1)+"-"+DateTime.Now.Year,
                (DateTime.Now.Year-2)+"-"+(DateTime.Now.Year-1),
                (DateTime.Now.Year-3)+"-"+(DateTime.Now.Year-2),
                (DateTime.Now.Year-4)+""
            });
            comboBoxCellType.Items = year.ToArray();
            fpSpread.Sheets[0].Cells[1, 4].CellType = comboBoxCellType;
            selectedYr = year[0];
            comboBoxCellType.Editable = false;
            comboBoxCellType.MaxDrop = 4;
            fpSpread.Sheets[0].Cells[1, 4].Text = (DateTime.Now.Year - 1) + "-" + DateTime.Now.Year;
            fpSpread.Sheets[0].Columns[3].Locked = true;

        }
        private void AddEventHandlers()
        {
            fpSpread.ComboSelChange += FpSpread_ComboSelChange;
            fpSpread.EditChange += FpSpread_EditChange;
        }

        private void SetHeaderAndText()
        {
            fpSpread.Sheets[0].Columns[3].Locked = true;
            fpSpread.Sheets[0].Rows[0, 2].Locked = true;
            fpSpread.Sheets[0].Cells[1, 4, 1, 4].Locked = false;
            fpSpread.Sheets[0].SetRowHeight(2, 25);
            fpSpread.Sheets[0].Rows[2].BackColor = Color.Gray;
            fpSpread.Sheets[0].Rows[1].BackColor = Color.FromArgb(187, 189, 178);
            fpSpread.Sheets[0].Rows[1].ForeColor = Color.DarkRed;
            fpSpread.Sheets[0].Rows[2].ForeColor = Color.White;
            fpSpread.Sheets[0].Columns[9, fpSpread.Sheets[0].Columns.Count - 1].Locked = true;
            fpSpread.Sheets[0].Cells[0, 0].Text = "MSC Point Table";
            fpSpread.Sheets[0].AddSpanCell(0, 0, 1, 15);
            fpSpread.Sheets[0].AddSpanCell(1, 0, 1, 4);
            fpSpread.Sheets[0].Rows[0].Height = 50;
            fpSpread.Sheets[0].Cells[2, 0].Text = "#";
            fpSpread.Sheets[0].Cells[2, 1].Text = "CR";
            fpSpread.Sheets[0].Cells[2, 2].Text = "PR";
            fpSpread.Sheets[0].Cells[2, 3].Text = "T";
            fpSpread.Sheets[0].Cells[2, 4].Text = "Team";
            fpSpread.Sheets[0].Cells[2, 5].Text = "M";
            fpSpread.Sheets[0].Cells[2, 6].Text = "W";
            fpSpread.Sheets[0].Cells[2, 7].Text = "L";
            fpSpread.Sheets[0].Cells[2, 8].Text = "D";
            fpSpread.Sheets[0].Cells[2, 9].Text = "W%L%D%";
            fpSpread.Sheets[0].Cells[2, 10].Text = "Avg W%";
            fpSpread.Sheets[0].Cells[2, 11].Text = "Avg L%";
            fpSpread.Sheets[0].Cells[2, 12].Text = "Points";
            fpSpread.Sheets[0].Cells[2, 13].Text = "Last 5 Matches";
            fpSpread.Sheets[0].Cells[2, 14].Text = "% vs Target";
            fpSpread.Sheets[0].FrozenRowCount = 3;
        }
        private void AddAverageDatabarFormatting(int rowCnt, int col, int maxValue, Color fillcolor)
        {
            FarPoint.Win.Spread.DatabarConditionalFormattingRule databarConditionalFormattingRule1 = new FarPoint.Win.Spread.DatabarConditionalFormattingRule();
            databarConditionalFormattingRule1.BorderColor = fillcolor;
            databarConditionalFormattingRule1.FillColor = fillcolor;
            databarConditionalFormattingRule1.Maximum = new FarPoint.Win.Spread.ConditionalFormattingValue(maxValue, FarPoint.Win.Spread.ConditionalFormattingValueType.Number);
            databarConditionalFormattingRule1.Priority = 3;

            databarConditionalFormattingRule1.ShowBorder = true;
            this.fpSpread.Sheets[0].SetConditionalFormatting(new FarPoint.Win.Spread.Model.CellRange[] {
            new FarPoint.Win.Spread.Model.CellRange(3, col, rowCnt, 1)}, new FarPoint.Win.Spread.IConditionalFormattingRule[] {
            databarConditionalFormattingRule1});
        }
        private void SetColumnsRowsVisibility()
        {
            //Set visibility of headers and columns
            fpSpread.Sheets[0].ColumnHeader.Visible = false;
            fpSpread.Sheets[0].RowHeader.Visible = false;
            //  fpSpread.Sheets[0].Columns[0].Visible = false;
        }
        private void SetColor()
        {
            //Set alternative row color
            fpSpread.Sheets[0].AlternatingRows.Count = 2;
            fpSpread.Sheets[0].AlternatingRows[0].BackColor = Color.FromArgb(246, 246, 246);
            fpSpread.Sheets[0].AlternatingRows[1].BackColor = Color.FromArgb(228, 228, 228);
        }
        private void CreateSparkLineForWinLoss()
        {
            int count = pointTableListCurrent.Count();
            for (int i = 3; i < count + 3; i++)
            {
                this.BindSparklineInRow(i, 9, false);
                SetSerialCount(i);
            }

            //Add percentage vs targate sparkline
            _bullGroup = null;
            for (int i = 3; i < count + 3; i++)
            {
                this.BindSparklineInRow(i, 14, true);
            }

            //add win/loss sparkline
            _bullGroup = null;
            for (int i = 3; i < count + 3; i++)
            {
                this.BindExcelSparklineInRow(i, 13, WinLossStatusOfLast5Match(pointTableListCurrent[i - 3].TeamId));
            }

            //add up/down sparkline
            _bullGroup = null;
            FarPoint.Win.Spread.Model.ReferenceStyle referenceStyle = this.fpSpread.ActiveSheet.ReferenceStyle;
            this.fpSpread.ActiveSheet.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            for (int i = 3; i < count + 3; i++)
            {
                this.BindUpDownSparklineInRow(i, 3);
            }
            this.fpSpread.ActiveSheet.ReferenceStyle = referenceStyle;
        }
        private void SetSerialCount(int row)
        {
            fpSpread.Sheets[0].Cells[row, 0].Text = (row - 2).ToString();
        }
        private void BindUpDownSparklineInRow(int row, int col)
        {
            FarPoint.Win.Spread.ExcelSparklineGroup excelSparklineGroup3 = new FarPoint.Win.Spread.ExcelSparklineGroup();
            FarPoint.Win.Spread.ExcelSparklineSetting excelSparklineSetting3 = new FarPoint.Win.Spread.ExcelSparklineSetting();
            FarPoint.Win.Spread.ExcelSparkline excelSparkline3 = new FarPoint.Win.Spread.ExcelSparkline();
            this.fpSpread.ActiveSheet.SparklineContainer.Add(excelSparklineGroup3);
            excelSparklineGroup3.Renderer = new CustomUpDownSparkline(Color.FromArgb(19, 122, 24), Color.FromArgb(250, 34, 14), Color.FromArgb(249, 191, 39));
            excelSparklineGroup3.Setting = excelSparklineSetting3;
            excelSparkline3.Formula = "RC[-2]:RC[-1]";
            excelSparklineSetting3.ShowNegative = true;
            excelSparkline3.Column = col;
            excelSparkline3.Row = row;
            excelSparklineGroup3.Add(excelSparkline3);
     
        }
        private void BindExcelSparklineInRow(int row, int col, int[] data)
        {
            int result = 0;
            if (Int32.TryParse(fpSpread.Sheets[0].Cells[row, 5].Text, out result) && fpSpread.Sheets[0].Cells[row, 5].Text != "0")
            {
                FarPoint.Win.Spread.ExcelSparklineGroup excelSparklineGroup3 = new FarPoint.Win.Spread.ExcelSparklineGroup();
                FarPoint.Win.Spread.ExcelSparklineSetting excelSparklineSetting3 = new FarPoint.Win.Spread.ExcelSparklineSetting();
                FarPoint.Win.Spread.ExcelSparkline excelSparkline3 = new FarPoint.Win.Spread.ExcelSparkline();
                this.fpSpread.ActiveSheet.SparklineContainer.Add(excelSparklineGroup3);
                excelSparklineGroup3.Renderer = new CustomWinLossSparklineRenderer(data, Color.FromArgb(19, 122, 24), Color.FromArgb(250, 34, 14), Color.FromArgb(249, 191, 39));
                excelSparklineGroup3.Setting = excelSparklineSetting3;
                excelSparklineSetting3.ShowNegative = true;
                excelSparkline3.Column = col;
                excelSparkline3.Row = row;
                excelSparklineGroup3.Add(excelSparkline3);
            }
            else
            {
                FarPoint.Win.Spread.ExcelSparklineGroup excelSparklineGroup3 = new FarPoint.Win.Spread.ExcelSparklineGroup();
                FarPoint.Win.Spread.ExcelSparklineSetting excelSparklineSetting3 = new FarPoint.Win.Spread.ExcelSparklineSetting();
                FarPoint.Win.Spread.ExcelSparkline excelSparkline3 = new FarPoint.Win.Spread.ExcelSparkline();
                this.fpSpread.ActiveSheet.SparklineContainer.Add(excelSparklineGroup3);
                excelSparklineGroup3.Renderer = new CustomWinLossSparklineRenderer(data, Color.Transparent, Color.Transparent, Color.Transparent);
                excelSparklineGroup3.Setting = excelSparklineSetting3;
                excelSparklineSetting3.ShowNegative = true;
                excelSparkline3.Column = col;
                excelSparkline3.Row = row;
                excelSparklineGroup3.Add(excelSparkline3);
            }
        }
        private void BindSparklineInRow(int row, int col, bool percentageVsTarget)
        {
            BulletChartSparklineSetting bulletSetting = new BulletChartSparklineSetting(Color.FromArgb(19, 122, 24), Color.FromArgb(250, 34, 14), Color.FromArgb(249, 191, 39), percentageVsTarget, 10.0);
            BulletChartSparklineGroup bulletGroup = new BulletChartSparklineGroup();
            bulletGroup.Setting = bulletSetting;
            SheetCellRange a1 = new SheetCellRange(this.fpSpread.Sheets[0], row, 5, 1, 1);
            SheetCellRange a2 = new SheetCellRange(this.fpSpread.Sheets[0], row, 6, 1, 1);
            SheetCellRange a3 = new SheetCellRange(this.fpSpread.Sheets[0], row, 7, 1, 1);
            SheetCellRange a4 = new SheetCellRange(this.fpSpread.Sheets[0], row, 8, 1, 1);
            BulletChartSparkline bulletSparkline = new BulletChartSparkline(this.fpSpread.Sheets[0], row, col, a1, a2, a3, a4);
            if (_bullGroup == null)
            {
                _bullGroup = new BulletChartSparklineGroup();
                _bullGroup.Setting = bulletSetting;
                _bullGroup.Add(bulletSparkline);
                this.fpSpread.ActiveSheet.SparklineContainer.Add(_bullGroup);
            }
            else
            {
                _bullGroup.Add(bulletSparkline);
            }
        }
        private BulletChartSparklineGroup _bullGroup = null;


        private void UpdateDataOnSpread()
        {
            int _rowCnt = fpSpread.Sheets[0].Rows.Count;

            if (pointTableListCurrent.Count > 0)
            {
                // for point table               
                SpreadDataBindingAdapter data = new SpreadDataBindingAdapter();
                // Assign the datasource to a point table list
                data.DataSource = pointTableListCurrent;
                data.Spread = fpSpread;
                data.SheetName = "Sheet1";
                data.MapperInfo = new MapperInfo(3, 0, pointTableListCurrent.Count, 8);
                data.FillSpreadDataByDataSource();
                AddDrawMatchFormula(pointTableListCurrent.Count());
                AddAverageDatabarFormatting(pointTableListCurrent.Count(), 10, 100, Color.FromArgb(19, 122, 24));
                AddAverageDatabarFormatting(pointTableListCurrent.Count(), 11, 100, Color.FromArgb(250, 34, 14));
                AddAverageDatabarFormatting(pointTableListCurrent.Count(), 12, pointTableListCurrent[0].TotalMatch * 2, Color.FromArgb(198, 198, 198));
                SetRowHeight(pointTableListCurrent.Count());

            }
            else
            {
                fpSpread.Sheets[0].AddSpanCell(3, 0, fpSpread.Sheets[0].RowCount, fpSpread.Sheets[0].ColumnCount);
                fpSpread.Sheets[0].Cells[3, 0].Text = "No record found.";
            }
            UpdateDataCellType();
        }
        private void UpdateDataCellType()
        {
            NumberCellType numberCellType = new NumberCellType();
            numberCellType.NullDisplay = "0";
            numberCellType.DecimalPlaces = 0;
            numberCellType.MinimumValue = 0;
            fpSpread.Sheets[0].Cells[3, 3, fpSpread.Sheets[0].RowCount - 1, 3].Locked = true;
            fpSpread.Sheets[0].Cells[3, 5, fpSpread.Sheets[0].RowCount - 1, 5].Locked = true;
            fpSpread.Sheets[0].Cells[3, 5, fpSpread.Sheets[0].RowCount - 1, 8].CellType = numberCellType;


        }
        private void AddDrawMatchFormula(int countrow)
        {
            for (int i = 3; i < countrow + 3; i++)
            {
                fpSpread.Sheets[0].Cells[i, 8].Formula = "F" + (i + 1) + "-G" + (i + 1) + "-H" + (i + 1);
                fpSpread.Sheets[0].Cells[i, 10].Formula = "(G" + (i + 1) + "*100)/F" + (i + 1);
                fpSpread.Sheets[0].Cells[i, 11].Formula = "(H" + (i + 1) + "*100)/F" + (i + 1);
                fpSpread.Sheets[0].Cells[i, 12].Formula = "(G" + (i + 1) + "*2)+(I" + (i + 1) + "*1)";
            }
        }

        private List<MatchPointTable> CreatePointTable(List<Match> matchList)
        {
            List<MatchPointTable> pointTable = new List<MatchPointTable>();
            if (matchList.Count < 1 || teamList == null)
            {
                return pointTable;
            }

            foreach (var t in teamList.OrderBy(t => t.TeamId))
            {
                var p = new MatchPointTable()
                {
                    TeamId = t.TeamId,
                    TeamName = t.Name,
                    TotalLoss = matchList.Where(m => (m.Team1Id == t.TeamId || m.Team2Id == t.TeamId) && m.WinnerTeamId != t.TeamId && m.WinnerTeamId > 0).Count(),
                    TotalWin = matchList.Where(m => (m.Team1Id == t.TeamId || m.Team2Id == t.TeamId) && m.WinnerTeamId == t.TeamId).Count(),
                    TotalMatch = matchList.Where(m => (m.Team1Id == t.TeamId || m.Team2Id == t.TeamId)).Count()
                };
                pointTable.Add(p);
            }
            return pointTable;
        }
        private void UpdateRank(List<MatchPointTable> pointTableCurrent, List<MatchPointTable> pointTablePrevious)
        {
            pointTableCurrent.Sort((X, Y) => (Y.TotalWin * 2 + ((Y.TotalWin - Y.TotalLoss) * 1)).CompareTo((X.TotalWin * 2 + ((X.TotalWin - X.TotalLoss) * 1))));
            pointTablePrevious.Sort((X, Y) => (Y.TotalWin * 2 + ((Y.TotalWin - Y.TotalLoss) * 1)).CompareTo((X.TotalWin * 2 + ((X.TotalWin - X.TotalLoss) * 1))));
            //Update Rank
            for (int i = 0; i < pointTableCurrent.Count(); i++)
            {
                pointTableCurrent[i].CurrentRank = pointTableCurrent[i].TotalMatch == 0 ? "-" : (i + 1) + "";
                pointTableCurrent[i].PreviousRank = pointTablePrevious.Count > 0 ? (pointTablePrevious.IndexOf(pointTablePrevious.SingleOrDefault(t => t.TeamId == pointTableCurrent[i].TeamId)) + 1).ToString() : "-";
            }
            if (pointTablePrevious.Count < 1)
            {
                return;
            }

            for (int i = 0; i < pointTableCurrent.Count(); i++)
            {
                pointTableCurrent[i].PreviousRank = pointTableCurrent[i].PreviousRank == "0" ? "-" : (pointTablePrevious[Convert.ToInt32(pointTableCurrent[i].PreviousRank) - 1].TotalMatch == 0) ? "-" : pointTableCurrent[i].PreviousRank;
            }
        }
        private int[] WinLossStatusOfLast5Match(int teamId)
        {
            int[] matchStatus = new int[5];

            Match[] matches = matchListCurrent.OrderBy(m => m.MatchDate).Reverse().Where(m => m.Team1Id == teamId || m.Team2Id == teamId).Take(5).ToArray();
            int i = 0;
            foreach (Match match in matches)
            {
                matchStatus[i] = match.WinnerTeamId == teamId ? 1 : (match.WinnerTeamId != teamId && (match.WinnerTeamId == match.Team1Id || match.WinnerTeamId == match.Team2Id)) ? -1 : 0;
                i++;
            }
            return matchStatus;
        }

        #endregion
    }
}
